package io.renren.dao;

import io.renren.common.dao.BaseDao;
import io.renren.entity.AutodecoratemEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * ${comments}
 *
 * @author Sen 524227263@qq.com
 * @since 1.0.0 2024-05-28
 */
@Mapper
public interface AutodecoratemDao extends BaseDao<AutodecoratemEntity> {

    @Select("select distinct UCML_CONTACT.PersonName from AutoRepairDispatchD  " +
            "left join UCML_CONTACT on UCML_CONTACT.UCML_CONTACTOID=AutoRepairDispatchD.UCML_CONTACT_FK " +
            "where AutoRepairDispatchD.DispatchType='1' and AutoRepairDispatchD.SourceBillOID=#{autoDecorateMoId}")
    List<Map<String, Object>> gettechnicianInfoSql(@Param("autoDecorateMoId") String autoDecorateMoId);
}